from google.appengine.ext import db

class LyricLrc(db.Model):
    lrc_str = db.TextProperty()
    #mid = db.IntegerPro
    add_dt = db.DateTimeProperty(auto_now=True)
    hot_num = db.IntegerProperty()
    name = db.StringProperty()

class LyricLine(db.Model):
    line = db.StringProperty()
    split_anno = db.StringProperty()
    time = db.FloatProperty()
    lrc = db.ReferenceProperty(LyricLrc)
    anno_dt = db.DateTimeProperty(auto_now=True)

class EmoAnno(db.Model):
    lrc = db.ReferenceProperty(LyricLrc)
    emo = db.StringProperty()
    anno_desc = db.StringProperty()
    anno_ip = db.StringProperty()
    anno_dt = db.DateTimeProperty(auto_now=True)

class EmoAnnoOk(db.Model):
    lrc = db.ReferenceProperty(LyricLrc)
    anno_ok = db.IntegerProperty(default=0)


